doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

WeekNum

Generates the calendar week number for a certain date, counting the first week ...

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6